Running the Cash Flow Forecaster utility

Before generating the cash flow forecasting data for a budget, you can run the Cash Flow Forecaster utility to test the data by viewing and auditing the details for specific instrument records.

NOTE: Before running this utility, you must first configure the Interest Rate driver and Cash Flow Forecaster driver for the budget you want to generate cash flow forecast data.

To run the Cash Flow Forecaster:

  1. Open the active financial planning budget.
  2. Click the Cash Flow tab.

  3. Under Test instrument records, click Open.

    NOTE: The Cash Flow Forecaster opens in the Desktop Client.

  4. To select an instrument record, in the Main ribbon tab, click Refresh.

  5. In the Refresh Variables dialog, do the following:

    Refresh Variable Description
    Select a data table Select the Loans, CDs, or Treasury table to query the data.
    Select an instrument Select the instrument in which to calculate and test the cash flow forecast.

  6. To review and audit the results, run the following reports:

    NOTE: Some reports may be available in both Web and Excel format or only in Excel format. If you choose to use the Excel version, the report will open in the Desktop Client.

    Report Description
    Cash Flow Forecaster Log Instrument Detail report View the cash flow forecast data at the instrument detail level derived from the CFFLog (a tab in the Cash Flow Forecaster).
    Cash Flow Forecaster Log report View the cash flow forecast data at the instrument summary level derived from the CFFLog (a tab in the Cash Flow Forecaster).
    Cash Flow Results Analysis

    A dashboard report that presents cash flow forecaster results using the data in the Account, Product, and Interest Type (ITYPE) dimensions.

    The Cash Flow details include:

    • Options that allow you to filter by a specific GL account, related product codes, and interest types (ITYPE).

    • An ending balance trend column graph with line graphs for weighted average interest rates and weighted average FTP rates

    • A cash flow analysis graph that decomposes cash flows into principal payment cash flow, balloon cash flow and cash flow related to CPR. It also shows the weighted average interest rate on cash flows.

    • A grid showing data that supports the cash flow detail graphs.

Troubleshooting Cash Flow Forecaster error messages

The following table includes error messages and their possible causes:

Error Message Cause of Message
Refresh the Cash Flow Forecaster Console to update file group information. This message will occur if Axiom did not refresh workbook AQs A method of querying data from the database and updating a specified range in the sheet with the data. Formatting and formulas can be applied to inserted data rows, using calc methods. on open. Manually refresh the Cash Flow Forecaster to load budget metadata.
The selected Filegroup ID does not have an associated Cash Flow Forecaster driver table.

The following may be causes for this error:

  • The Cash Flow Forecaster was not refreshed with the most current table information.
  • The Cash Flow Forecaster Driver.xlsx file was deleted from the Driver folder of the related budget.
The selected Filegroup ID does not have an associated interest rates driver table.

The following may be causes for this error:

  • The Cash Flow Forecaster was not refreshed with the most current table information.
  • The Cash Flow Forecaster Driver.xlsx file was deleted from the Driver folder of the related budget.
The selected Filegroup ID does not have an associated cash flow table. This could mean that the TargetCFTable table variable was either deleted or its resolved table name is an invalid table.
The InstModelStg table has 0 records for given Instrument data YRMO. This error message occurs only when the InstModelStg does not have any records of the same YRMO, which is derived from the base year and base period of the file group. The InstModelStg table should contain records with a YRMO value consistent with the base year and base period of the budget.